{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from pandas.tseries.offsets import *\n",
    "from xiao_utils import f"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sale_date</th>\n",
       "      <th>class_id</th>\n",
       "      <th>sale_quantity</th>\n",
       "      <th>brand_id</th>\n",
       "      <th>compartment</th>\n",
       "      <th>type_id</th>\n",
       "      <th>level_id</th>\n",
       "      <th>department_id</th>\n",
       "      <th>TR</th>\n",
       "      <th>gearbox_type</th>\n",
       "      <th>...</th>\n",
       "      <th>engine_torque</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>total_quality</th>\n",
       "      <th>equipment_quality</th>\n",
       "      <th>rated_passenger</th>\n",
       "      <th>wheelbase</th>\n",
       "      <th>front_track</th>\n",
       "      <th>rear_track</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>289403</td>\n",
       "      <td>94</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>170.0</td>\n",
       "      <td>4440</td>\n",
       "      <td>1833</td>\n",
       "      <td>1545</td>\n",
       "      <td>1695</td>\n",
       "      <td>1320</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1556</td>\n",
       "      <td>1562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>745137</td>\n",
       "      <td>435</td>\n",
       "      <td>637</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>DCT</td>\n",
       "      <td>...</td>\n",
       "      <td>159.0</td>\n",
       "      <td>4534</td>\n",
       "      <td>1823</td>\n",
       "      <td>1483</td>\n",
       "      <td>1711</td>\n",
       "      <td>1336</td>\n",
       "      <td>5</td>\n",
       "      <td>2648</td>\n",
       "      <td>1553</td>\n",
       "      <td>1544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>714860</td>\n",
       "      <td>180</td>\n",
       "      <td>831</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>176.0</td>\n",
       "      <td>4720</td>\n",
       "      <td>1815</td>\n",
       "      <td>1465</td>\n",
       "      <td>1860</td>\n",
       "      <td>1459</td>\n",
       "      <td>5</td>\n",
       "      <td>2770</td>\n",
       "      <td>1579</td>\n",
       "      <td>1589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>175962</td>\n",
       "      <td>40</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4475</td>\n",
       "      <td>1706</td>\n",
       "      <td>1469</td>\n",
       "      <td>1625</td>\n",
       "      <td>1145</td>\n",
       "      <td>5</td>\n",
       "      <td>2603</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>270690</td>\n",
       "      <td>19</td>\n",
       "      <td>98</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>146.5</td>\n",
       "      <td>4415</td>\n",
       "      <td>1685</td>\n",
       "      <td>1850</td>\n",
       "      <td>1825</td>\n",
       "      <td>1236</td>\n",
       "      <td>5</td>\n",
       "      <td>2720</td>\n",
       "      <td>1420</td>\n",
       "      <td>1440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>290854</td>\n",
       "      <td>53</td>\n",
       "      <td>537</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4585</td>\n",
       "      <td>1820</td>\n",
       "      <td>1685</td>\n",
       "      <td>2010</td>\n",
       "      <td>1540</td>\n",
       "      <td>5</td>\n",
       "      <td>2620</td>\n",
       "      <td>1580</td>\n",
       "      <td>1580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>692703</td>\n",
       "      <td>81</td>\n",
       "      <td>807</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>202.0</td>\n",
       "      <td>4510</td>\n",
       "      <td>1852</td>\n",
       "      <td>1677</td>\n",
       "      <td>1900</td>\n",
       "      <td>1450</td>\n",
       "      <td>5</td>\n",
       "      <td>2650</td>\n",
       "      <td>1575</td>\n",
       "      <td>1570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>978089</td>\n",
       "      <td>37</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4425</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1611</td>\n",
       "      <td>1236</td>\n",
       "      <td>5</td>\n",
       "      <td>2650</td>\n",
       "      <td>1502</td>\n",
       "      <td>1492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>219195</td>\n",
       "      <td>115</td>\n",
       "      <td>638</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>210.0</td>\n",
       "      <td>4335</td>\n",
       "      <td>1814</td>\n",
       "      <td>1695</td>\n",
       "      <td>1895</td>\n",
       "      <td>1520</td>\n",
       "      <td>5</td>\n",
       "      <td>2560</td>\n",
       "      <td>1525</td>\n",
       "      <td>1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>851857</td>\n",
       "      <td>78</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>400.0</td>\n",
       "      <td>4812</td>\n",
       "      <td>1903</td>\n",
       "      <td>1680</td>\n",
       "      <td>2375</td>\n",
       "      <td>1885</td>\n",
       "      <td>5</td>\n",
       "      <td>2857</td>\n",
       "      <td>1645</td>\n",
       "      <td>1645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>304458</td>\n",
       "      <td>17</td>\n",
       "      <td>106</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>154.0</td>\n",
       "      <td>4630</td>\n",
       "      <td>1775</td>\n",
       "      <td>1480</td>\n",
       "      <td>1770</td>\n",
       "      <td>1265</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1535</td>\n",
       "      <td>1535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>349023</td>\n",
       "      <td>10</td>\n",
       "      <td>450</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>146.0</td>\n",
       "      <td>4567</td>\n",
       "      <td>1786</td>\n",
       "      <td>1456</td>\n",
       "      <td>1700</td>\n",
       "      <td>1195</td>\n",
       "      <td>5</td>\n",
       "      <td>2662</td>\n",
       "      <td>1540</td>\n",
       "      <td>1558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>281792</td>\n",
       "      <td>10</td>\n",
       "      <td>872</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>...</td>\n",
       "      <td>300.0</td>\n",
       "      <td>4319</td>\n",
       "      <td>1785</td>\n",
       "      <td>1441</td>\n",
       "      <td>1885</td>\n",
       "      <td>1435</td>\n",
       "      <td>5</td>\n",
       "      <td>2629</td>\n",
       "      <td>1539</td>\n",
       "      <td>1509</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>510309</td>\n",
       "      <td>83</td>\n",
       "      <td>953</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>350.0</td>\n",
       "      <td>4661</td>\n",
       "      <td>1898</td>\n",
       "      <td>1664</td>\n",
       "      <td>2360</td>\n",
       "      <td>1860</td>\n",
       "      <td>5</td>\n",
       "      <td>2873</td>\n",
       "      <td>1617</td>\n",
       "      <td>1613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>379876</td>\n",
       "      <td>7</td>\n",
       "      <td>985</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>230.0</td>\n",
       "      <td>4590</td>\n",
       "      <td>1820</td>\n",
       "      <td>1488</td>\n",
       "      <td>1736</td>\n",
       "      <td>1320</td>\n",
       "      <td>5</td>\n",
       "      <td>2675</td>\n",
       "      <td>1555</td>\n",
       "      <td>1550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>750340</td>\n",
       "      <td>29</td>\n",
       "      <td>864</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>215.0</td>\n",
       "      <td>4530</td>\n",
       "      <td>1900</td>\n",
       "      <td>1700</td>\n",
       "      <td>1860</td>\n",
       "      <td>1485</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1601</td>\n",
       "      <td>1602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>576298</td>\n",
       "      <td>158</td>\n",
       "      <td>304</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>138.0</td>\n",
       "      <td>5055</td>\n",
       "      <td>1695</td>\n",
       "      <td>1960</td>\n",
       "      <td>2160</td>\n",
       "      <td>1560</td>\n",
       "      <td>7-8</td>\n",
       "      <td>3000</td>\n",
       "      <td>1445</td>\n",
       "      <td>1420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>347384</td>\n",
       "      <td>28</td>\n",
       "      <td>831</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.5</td>\n",
       "      <td>4600</td>\n",
       "      <td>1780</td>\n",
       "      <td>1445</td>\n",
       "      <td>1720</td>\n",
       "      <td>1260</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1555</td>\n",
       "      <td>1568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>354068</td>\n",
       "      <td>718</td>\n",
       "      <td>692</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>154.0</td>\n",
       "      <td>4631</td>\n",
       "      <td>1760</td>\n",
       "      <td>1503</td>\n",
       "      <td>1650</td>\n",
       "      <td>1236</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1540</td>\n",
       "      <td>1540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>416749</td>\n",
       "      <td>29</td>\n",
       "      <td>537</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4270</td>\n",
       "      <td>1772</td>\n",
       "      <td>1605</td>\n",
       "      <td>1775</td>\n",
       "      <td>1205</td>\n",
       "      <td>5</td>\n",
       "      <td>2610</td>\n",
       "      <td>1540</td>\n",
       "      <td>1530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>125403</td>\n",
       "      <td>66</td>\n",
       "      <td>761</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>290.0</td>\n",
       "      <td>5266</td>\n",
       "      <td>1878</td>\n",
       "      <td>1772</td>\n",
       "      <td>2470</td>\n",
       "      <td>1930</td>\n",
       "      <td>7</td>\n",
       "      <td>3088</td>\n",
       "      <td>1593</td>\n",
       "      <td>1603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>409854</td>\n",
       "      <td>310</td>\n",
       "      <td>638</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>210.0</td>\n",
       "      <td>4649</td>\n",
       "      <td>1852</td>\n",
       "      <td>1710</td>\n",
       "      <td>2059</td>\n",
       "      <td>1560</td>\n",
       "      <td>5</td>\n",
       "      <td>2680</td>\n",
       "      <td>1565</td>\n",
       "      <td>1565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>786351</td>\n",
       "      <td>98</td>\n",
       "      <td>836</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.5</td>\n",
       "      <td>4570</td>\n",
       "      <td>1775</td>\n",
       "      <td>1445</td>\n",
       "      <td>1608</td>\n",
       "      <td>1233</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1549</td>\n",
       "      <td>1562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>281301</td>\n",
       "      <td>22</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>...</td>\n",
       "      <td>350.0</td>\n",
       "      <td>4872</td>\n",
       "      <td>1834</td>\n",
       "      <td>1484</td>\n",
       "      <td>2120</td>\n",
       "      <td>1600</td>\n",
       "      <td>5</td>\n",
       "      <td>2803</td>\n",
       "      <td>1577</td>\n",
       "      <td>1550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>654134</td>\n",
       "      <td>280</td>\n",
       "      <td>290</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>AMT</td>\n",
       "      <td>...</td>\n",
       "      <td>186.0</td>\n",
       "      <td>4620</td>\n",
       "      <td>1820</td>\n",
       "      <td>1750</td>\n",
       "      <td>1780</td>\n",
       "      <td>1410</td>\n",
       "      <td>5</td>\n",
       "      <td>2750</td>\n",
       "      <td>1554</td>\n",
       "      <td>1549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>379876</td>\n",
       "      <td>63</td>\n",
       "      <td>985</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>150.0</td>\n",
       "      <td>4558</td>\n",
       "      <td>1805</td>\n",
       "      <td>1505</td>\n",
       "      <td>1798</td>\n",
       "      <td>1370</td>\n",
       "      <td>5</td>\n",
       "      <td>2612</td>\n",
       "      <td>1525</td>\n",
       "      <td>1522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>745137</td>\n",
       "      <td>328</td>\n",
       "      <td>637</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>DCT</td>\n",
       "      <td>...</td>\n",
       "      <td>159.0</td>\n",
       "      <td>4368</td>\n",
       "      <td>1823</td>\n",
       "      <td>1483</td>\n",
       "      <td>1707</td>\n",
       "      <td>1332</td>\n",
       "      <td>5</td>\n",
       "      <td>2648</td>\n",
       "      <td>1553</td>\n",
       "      <td>1544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>425432</td>\n",
       "      <td>519</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4605</td>\n",
       "      <td>1765</td>\n",
       "      <td>1460</td>\n",
       "      <td>1775</td>\n",
       "      <td>1265</td>\n",
       "      <td>5</td>\n",
       "      <td>2610</td>\n",
       "      <td>1517</td>\n",
       "      <td>1493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>871642</td>\n",
       "      <td>25</td>\n",
       "      <td>637</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>240.0</td>\n",
       "      <td>4524</td>\n",
       "      <td>1838</td>\n",
       "      <td>1695</td>\n",
       "      <td>2092</td>\n",
       "      <td>1717</td>\n",
       "      <td>5</td>\n",
       "      <td>2690</td>\n",
       "      <td>1563</td>\n",
       "      <td>1565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2016-09-01</td>\n",
       "      <td>416749</td>\n",
       "      <td>72</td>\n",
       "      <td>537</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>169.0</td>\n",
       "      <td>4270</td>\n",
       "      <td>1772</td>\n",
       "      <td>1605</td>\n",
       "      <td>1775</td>\n",
       "      <td>1304</td>\n",
       "      <td>5</td>\n",
       "      <td>2610</td>\n",
       "      <td>1540</td>\n",
       "      <td>1530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20127</th>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>281301</td>\n",
       "      <td>44</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4872</td>\n",
       "      <td>1834</td>\n",
       "      <td>1484</td>\n",
       "      <td>2015</td>\n",
       "      <td>1495</td>\n",
       "      <td>5</td>\n",
       "      <td>2803</td>\n",
       "      <td>1577</td>\n",
       "      <td>1550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20128</th>\n",
       "      <td>2016-03-01</td>\n",
       "      <td>248352</td>\n",
       "      <td>8</td>\n",
       "      <td>831</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4370</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "      <td>1085</td>\n",
       "      <td>5</td>\n",
       "      <td>2570</td>\n",
       "      <td>1511</td>\n",
       "      <td>1515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20129</th>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>587678</td>\n",
       "      <td>146</td>\n",
       "      <td>537</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4294</td>\n",
       "      <td>1772</td>\n",
       "      <td>1605</td>\n",
       "      <td>1770</td>\n",
       "      <td>1204</td>\n",
       "      <td>5</td>\n",
       "      <td>2610</td>\n",
       "      <td>1535</td>\n",
       "      <td>1540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20130</th>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>628041</td>\n",
       "      <td>13</td>\n",
       "      <td>750</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>225.0</td>\n",
       "      <td>4255</td>\n",
       "      <td>1799</td>\n",
       "      <td>1452</td>\n",
       "      <td>1740</td>\n",
       "      <td>1260</td>\n",
       "      <td>5</td>\n",
       "      <td>2637</td>\n",
       "      <td>1549</td>\n",
       "      <td>1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20131</th>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>409854</td>\n",
       "      <td>9</td>\n",
       "      <td>638</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>210.0</td>\n",
       "      <td>4649</td>\n",
       "      <td>1852</td>\n",
       "      <td>1710</td>\n",
       "      <td>2106</td>\n",
       "      <td>1620</td>\n",
       "      <td>5</td>\n",
       "      <td>2680</td>\n",
       "      <td>1565</td>\n",
       "      <td>1565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20132</th>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>559132</td>\n",
       "      <td>41</td>\n",
       "      <td>692</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>234.0</td>\n",
       "      <td>4868</td>\n",
       "      <td>1830</td>\n",
       "      <td>1490</td>\n",
       "      <td>1900</td>\n",
       "      <td>1469</td>\n",
       "      <td>5</td>\n",
       "      <td>2775</td>\n",
       "      <td>1585</td>\n",
       "      <td>1585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20133</th>\n",
       "      <td>2016-04-01</td>\n",
       "      <td>468392</td>\n",
       "      <td>17</td>\n",
       "      <td>537</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4930</td>\n",
       "      <td>1845</td>\n",
       "      <td>1470</td>\n",
       "      <td>1920</td>\n",
       "      <td>1495</td>\n",
       "      <td>5</td>\n",
       "      <td>2775</td>\n",
       "      <td>1595</td>\n",
       "      <td>1585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20134</th>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>291514</td>\n",
       "      <td>50</td>\n",
       "      <td>783</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>160.0</td>\n",
       "      <td>4160</td>\n",
       "      <td>1810</td>\n",
       "      <td>1635</td>\n",
       "      <td>1645</td>\n",
       "      <td>1270</td>\n",
       "      <td>5</td>\n",
       "      <td>2560</td>\n",
       "      <td>1560</td>\n",
       "      <td>1560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20135</th>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>349023</td>\n",
       "      <td>29</td>\n",
       "      <td>450</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>235.0</td>\n",
       "      <td>4510</td>\n",
       "      <td>1797</td>\n",
       "      <td>1477</td>\n",
       "      <td>1893</td>\n",
       "      <td>1485</td>\n",
       "      <td>5</td>\n",
       "      <td>2685</td>\n",
       "      <td>1535</td>\n",
       "      <td>1557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20136</th>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>953842</td>\n",
       "      <td>218</td>\n",
       "      <td>831</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>203.0</td>\n",
       "      <td>4480</td>\n",
       "      <td>1855</td>\n",
       "      <td>1645</td>\n",
       "      <td>2090</td>\n",
       "      <td>1525</td>\n",
       "      <td>5</td>\n",
       "      <td>2670</td>\n",
       "      <td>1625</td>\n",
       "      <td>1636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20137</th>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>810398</td>\n",
       "      <td>67</td>\n",
       "      <td>750</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4282</td>\n",
       "      <td>1706</td>\n",
       "      <td>1475</td>\n",
       "      <td>1635</td>\n",
       "      <td>1155</td>\n",
       "      <td>5</td>\n",
       "      <td>2603</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20138</th>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>516750</td>\n",
       "      <td>101</td>\n",
       "      <td>98</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>146.5</td>\n",
       "      <td>4500</td>\n",
       "      <td>1721</td>\n",
       "      <td>1715</td>\n",
       "      <td>1825</td>\n",
       "      <td>1260</td>\n",
       "      <td>7-8</td>\n",
       "      <td>2720</td>\n",
       "      <td>1430</td>\n",
       "      <td>1450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20139</th>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>671482</td>\n",
       "      <td>77</td>\n",
       "      <td>637</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>DCT</td>\n",
       "      <td>...</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4280</td>\n",
       "      <td>1785</td>\n",
       "      <td>1658</td>\n",
       "      <td>1670</td>\n",
       "      <td>1295</td>\n",
       "      <td>5</td>\n",
       "      <td>2530</td>\n",
       "      <td>1527</td>\n",
       "      <td>1533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20140</th>\n",
       "      <td>2016-05-01</td>\n",
       "      <td>735971</td>\n",
       "      <td>619</td>\n",
       "      <td>761</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>143.0</td>\n",
       "      <td>4587</td>\n",
       "      <td>1798</td>\n",
       "      <td>1463</td>\n",
       "      <td>1660</td>\n",
       "      <td>1225</td>\n",
       "      <td>5</td>\n",
       "      <td>2640</td>\n",
       "      <td>1538</td>\n",
       "      <td>1541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20141</th>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>580470</td>\n",
       "      <td>100</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4562</td>\n",
       "      <td>1793</td>\n",
       "      <td>1468</td>\n",
       "      <td>1700</td>\n",
       "      <td>1220</td>\n",
       "      <td>5</td>\n",
       "      <td>2614</td>\n",
       "      <td>1518</td>\n",
       "      <td>1525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20142</th>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>453752</td>\n",
       "      <td>209</td>\n",
       "      <td>814</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>270.0</td>\n",
       "      <td>4755</td>\n",
       "      <td>1811</td>\n",
       "      <td>1455</td>\n",
       "      <td>1980</td>\n",
       "      <td>1560</td>\n",
       "      <td>5</td>\n",
       "      <td>2920</td>\n",
       "      <td>1531</td>\n",
       "      <td>1572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20143</th>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>209945</td>\n",
       "      <td>296</td>\n",
       "      <td>814</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>310.0</td>\n",
       "      <td>5055</td>\n",
       "      <td>1860</td>\n",
       "      <td>1491</td>\n",
       "      <td>2250</td>\n",
       "      <td>1790</td>\n",
       "      <td>5</td>\n",
       "      <td>3108</td>\n",
       "      <td>1600</td>\n",
       "      <td>1627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20144</th>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>125403</td>\n",
       "      <td>25</td>\n",
       "      <td>761</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>240.0</td>\n",
       "      <td>5266</td>\n",
       "      <td>1878</td>\n",
       "      <td>1772</td>\n",
       "      <td>2470</td>\n",
       "      <td>1860</td>\n",
       "      <td>7</td>\n",
       "      <td>3088</td>\n",
       "      <td>1593</td>\n",
       "      <td>1603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20145</th>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>412240</td>\n",
       "      <td>94</td>\n",
       "      <td>783</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>150.0</td>\n",
       "      <td>4680</td>\n",
       "      <td>1800</td>\n",
       "      <td>1750</td>\n",
       "      <td>1975</td>\n",
       "      <td>1450</td>\n",
       "      <td>7</td>\n",
       "      <td>2780</td>\n",
       "      <td>1495</td>\n",
       "      <td>1505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20146</th>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>219195</td>\n",
       "      <td>85</td>\n",
       "      <td>638</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>210.0</td>\n",
       "      <td>4335</td>\n",
       "      <td>1814</td>\n",
       "      <td>1695</td>\n",
       "      <td>1895</td>\n",
       "      <td>1520</td>\n",
       "      <td>5</td>\n",
       "      <td>2560</td>\n",
       "      <td>1525</td>\n",
       "      <td>1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20147</th>\n",
       "      <td>2016-06-01</td>\n",
       "      <td>671482</td>\n",
       "      <td>17</td>\n",
       "      <td>637</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4280</td>\n",
       "      <td>1785</td>\n",
       "      <td>1658</td>\n",
       "      <td>1620</td>\n",
       "      <td>1245</td>\n",
       "      <td>5</td>\n",
       "      <td>2530</td>\n",
       "      <td>1527</td>\n",
       "      <td>1533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20148</th>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>290854</td>\n",
       "      <td>18</td>\n",
       "      <td>537</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4585</td>\n",
       "      <td>1820</td>\n",
       "      <td>1685</td>\n",
       "      <td>2010</td>\n",
       "      <td>1540</td>\n",
       "      <td>5</td>\n",
       "      <td>2620</td>\n",
       "      <td>1580</td>\n",
       "      <td>1580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20149</th>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>349023</td>\n",
       "      <td>10</td>\n",
       "      <td>450</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>146.0</td>\n",
       "      <td>4567</td>\n",
       "      <td>1786</td>\n",
       "      <td>1456</td>\n",
       "      <td>1700</td>\n",
       "      <td>1225</td>\n",
       "      <td>5</td>\n",
       "      <td>2662</td>\n",
       "      <td>1540</td>\n",
       "      <td>1558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20150</th>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>883691</td>\n",
       "      <td>217</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4865</td>\n",
       "      <td>1820</td>\n",
       "      <td>1475</td>\n",
       "      <td>2000</td>\n",
       "      <td>1545</td>\n",
       "      <td>4-5</td>\n",
       "      <td>2812</td>\n",
       "      <td>1552</td>\n",
       "      <td>1551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20151</th>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>347384</td>\n",
       "      <td>18</td>\n",
       "      <td>831</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.5</td>\n",
       "      <td>4600</td>\n",
       "      <td>1780</td>\n",
       "      <td>1445</td>\n",
       "      <td>1700</td>\n",
       "      <td>1210</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1555</td>\n",
       "      <td>1568</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20152</th>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>810398</td>\n",
       "      <td>10</td>\n",
       "      <td>750</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4282</td>\n",
       "      <td>1706</td>\n",
       "      <td>1475</td>\n",
       "      <td>1600</td>\n",
       "      <td>1120</td>\n",
       "      <td>5</td>\n",
       "      <td>2603</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20153</th>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>175962</td>\n",
       "      <td>126</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4473</td>\n",
       "      <td>1706</td>\n",
       "      <td>1469</td>\n",
       "      <td>1635</td>\n",
       "      <td>1155</td>\n",
       "      <td>5</td>\n",
       "      <td>2603</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20154</th>\n",
       "      <td>2016-07-01</td>\n",
       "      <td>395234</td>\n",
       "      <td>9</td>\n",
       "      <td>841</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>200.0</td>\n",
       "      <td>4805</td>\n",
       "      <td>1860</td>\n",
       "      <td>1458</td>\n",
       "      <td>2065</td>\n",
       "      <td>1580</td>\n",
       "      <td>5</td>\n",
       "      <td>2815</td>\n",
       "      <td>1584</td>\n",
       "      <td>1551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20155</th>\n",
       "      <td>2016-08-01</td>\n",
       "      <td>587678</td>\n",
       "      <td>194</td>\n",
       "      <td>537</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>...</td>\n",
       "      <td>169.0</td>\n",
       "      <td>4294</td>\n",
       "      <td>1772</td>\n",
       "      <td>1605</td>\n",
       "      <td>1770</td>\n",
       "      <td>1302</td>\n",
       "      <td>5</td>\n",
       "      <td>2610</td>\n",
       "      <td>1535</td>\n",
       "      <td>1540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20156</th>\n",
       "      <td>2016-08-01</td>\n",
       "      <td>248352</td>\n",
       "      <td>218</td>\n",
       "      <td>831</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>AT</td>\n",
       "      <td>...</td>\n",
       "      <td>135.0</td>\n",
       "      <td>4370</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "      <td>1083</td>\n",
       "      <td>5</td>\n",
       "      <td>2570</td>\n",
       "      <td>1511</td>\n",
       "      <td>1515</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20157 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       sale_date  class_id  sale_quantity  brand_id  compartment  type_id  \\\n",
       "0     2016-09-01    289403             94        12            2        1   \n",
       "1     2016-09-01    745137            435       637            3        2   \n",
       "2     2016-09-01    714860            180       831            3        2   \n",
       "3     2016-09-01    175962             40       750            3        2   \n",
       "4     2016-09-01    270690             19        98            2        3   \n",
       "5     2016-09-01    290854             53       537            2        1   \n",
       "6     2016-09-01    692703             81       807            2        1   \n",
       "7     2016-09-01    978089             37        12            2        2   \n",
       "8     2016-09-01    219195            115       638            2        1   \n",
       "9     2016-09-01    851857             78        75            2        1   \n",
       "10    2016-09-01    304458             17       106            3        2   \n",
       "11    2016-09-01    349023             10       450            3        2   \n",
       "12    2016-09-01    281792             10       872            2        2   \n",
       "13    2016-09-01    510309             83       953            2        1   \n",
       "14    2016-09-01    379876              7       985            3        2   \n",
       "15    2016-09-01    750340             29       864            2        1   \n",
       "16    2016-09-01    576298            158       304            2        3   \n",
       "17    2016-09-01    347384             28       831            3        2   \n",
       "18    2016-09-01    354068            718       692            3        2   \n",
       "19    2016-09-01    416749             29       537            2        1   \n",
       "20    2016-09-01    125403             66       761            2        3   \n",
       "21    2016-09-01    409854            310       638            2        1   \n",
       "22    2016-09-01    786351             98       836            3        2   \n",
       "23    2016-09-01    281301             22       750            3        2   \n",
       "24    2016-09-01    654134            280       290            2        1   \n",
       "25    2016-09-01    379876             63       985            3        2   \n",
       "26    2016-09-01    745137            328       637            2        2   \n",
       "27    2016-09-01    425432            519       750            3        2   \n",
       "28    2016-09-01    871642             25       637            2        1   \n",
       "29    2016-09-01    416749             72       537            2        1   \n",
       "...          ...       ...            ...       ...          ...      ...   \n",
       "20127 2016-03-01    281301             44       750            3        2   \n",
       "20128 2016-03-01    248352              8       831            3        2   \n",
       "20129 2016-04-01    587678            146       537            2        1   \n",
       "20130 2016-04-01    628041             13       750            2        2   \n",
       "20131 2016-04-01    409854              9       638            2        1   \n",
       "20132 2016-04-01    559132             41       692            3        2   \n",
       "20133 2016-04-01    468392             17       537            3        2   \n",
       "20134 2016-05-01    291514             50       783            2        1   \n",
       "20135 2016-05-01    349023             29       450            2        2   \n",
       "20136 2016-05-01    953842            218       831            2        1   \n",
       "20137 2016-05-01    810398             67       750            2        2   \n",
       "20138 2016-05-01    516750            101        98            2        3   \n",
       "20139 2016-05-01    671482             77       637            2        1   \n",
       "20140 2016-05-01    735971            619       761            3        2   \n",
       "20141 2016-06-01    580470            100       750            3        2   \n",
       "20142 2016-06-01    453752            209       814            3        2   \n",
       "20143 2016-06-01    209945            296       814            3        2   \n",
       "20144 2016-06-01    125403             25       761            2        3   \n",
       "20145 2016-06-01    412240             94       783            2        1   \n",
       "20146 2016-06-01    219195             85       638            2        1   \n",
       "20147 2016-06-01    671482             17       637            2        1   \n",
       "20148 2016-07-01    290854             18       537            2        1   \n",
       "20149 2016-07-01    349023             10       450            3        2   \n",
       "20150 2016-07-01    883691            217       750            3        2   \n",
       "20151 2016-07-01    347384             18       831            3        2   \n",
       "20152 2016-07-01    810398             10       750            2        2   \n",
       "20153 2016-07-01    175962            126       750            3        2   \n",
       "20154 2016-07-01    395234              9       841            3        2   \n",
       "20155 2016-08-01    587678            194       537            2        1   \n",
       "20156 2016-08-01    248352            218       831            3        2   \n",
       "\n",
       "       level_id  department_id TR gearbox_type     ...      engine_torque  \\\n",
       "0           1.0              1  6           MT     ...              170.0   \n",
       "1           1.0              2  6          DCT     ...              159.0   \n",
       "2           2.0              3  6           AT     ...              176.0   \n",
       "3           1.0              4  6           AT     ...              155.0   \n",
       "4           3.0              1  5           MT     ...              146.5   \n",
       "5           1.0              5  0          CVT     ...              190.0   \n",
       "6           1.0              1  5           MT     ...              202.0   \n",
       "7           1.0              1  5           MT     ...              140.0   \n",
       "8           3.0              1  6           AT     ...              210.0   \n",
       "9           2.0              2  8           AT     ...              400.0   \n",
       "10          1.0              5  5           MT     ...              154.0   \n",
       "11          1.0              2  5           MT     ...              146.0   \n",
       "12          1.0              4  7          DCT     ...              300.0   \n",
       "13          2.0              4  9           AT     ...              350.0   \n",
       "14          1.0              6  6           AT     ...              230.0   \n",
       "15          1.0              1  6           MT     ...              215.0   \n",
       "16          2.0              1  5           MT     ...              138.0   \n",
       "17          1.0              3  6           AT     ...              155.5   \n",
       "18          1.0              5  0          CVT     ...              154.0   \n",
       "19          3.0              5  0          CVT     ...              155.0   \n",
       "20          2.0              2  6           AT     ...              290.0   \n",
       "21          1.0              1  6           MT     ...              210.0   \n",
       "22          1.0              3  6           MT     ...              155.5   \n",
       "23          2.0              4  7          DCT     ...              350.0   \n",
       "24          1.0              7  5          AMT     ...              186.0   \n",
       "25          1.0              6  4           AT     ...              150.0   \n",
       "26          1.0              2  6          DCT     ...              159.0   \n",
       "27          1.0              4  6           AT     ...              155.0   \n",
       "28          1.0              2  6           AT     ...              240.0   \n",
       "29          3.0              5  0          CVT     ...              169.0   \n",
       "...         ...            ... ..          ...     ...                ...   \n",
       "20127       2.0              4  7          DCT     ...              250.0   \n",
       "20128       3.0              3  4           AT     ...              155.0   \n",
       "20129       3.0              5  0          CVT     ...              155.0   \n",
       "20130       1.0              4  5           MT     ...              225.0   \n",
       "20131       1.0              1  6           MT     ...              210.0   \n",
       "20132       2.0              5  0          CVT     ...              234.0   \n",
       "20133       2.0              5  0          CVT     ...              190.0   \n",
       "20134       3.0              1  5           MT     ...              160.0   \n",
       "20135       1.0              2  6           AT     ...              235.0   \n",
       "20136       1.0              3  6           AT     ...              203.0   \n",
       "20137       1.0              4  6           AT     ...              155.0   \n",
       "20138       3.0              1  5           MT     ...              146.5   \n",
       "20139       3.0              2  6          DCT     ...              140.0   \n",
       "20140       1.0              2  5           MT     ...              143.0   \n",
       "20141       1.0              4  5           MT     ...              155.0   \n",
       "20142       2.0              4  8           AT     ...              270.0   \n",
       "20143       4.0              4  8           AT     ...              310.0   \n",
       "20144       2.0              2  6           AT     ...              240.0   \n",
       "20145       2.0              1  5           MT     ...              150.0   \n",
       "20146       3.0              1  6           AT     ...              210.0   \n",
       "20147       3.0              2  5           MT     ...              140.0   \n",
       "20148       1.0              5  0          CVT     ...              190.0   \n",
       "20149       1.0              2  5           MT     ...              146.0   \n",
       "20150       2.0              4  7          DCT     ...              250.0   \n",
       "20151       1.0              3  6           MT     ...              155.5   \n",
       "20152       1.0              4  5           MT     ...              155.0   \n",
       "20153       1.0              4  6           AT     ...              155.0   \n",
       "20154       2.0              6  6           AT     ...              200.0   \n",
       "20155       3.0              5  0          CVT     ...              169.0   \n",
       "20156       3.0              3  4           AT     ...              135.0   \n",
       "\n",
       "      car_length  car_width  car_height  total_quality  equipment_quality  \\\n",
       "0           4440       1833        1545           1695               1320   \n",
       "1           4534       1823        1483           1711               1336   \n",
       "2           4720       1815        1465           1860               1459   \n",
       "3           4475       1706        1469           1625               1145   \n",
       "4           4415       1685        1850           1825               1236   \n",
       "5           4585       1820        1685           2010               1540   \n",
       "6           4510       1852        1677           1900               1450   \n",
       "7           4425       1789        1470           1611               1236   \n",
       "8           4335       1814        1695           1895               1520   \n",
       "9           4812       1903        1680           2375               1885   \n",
       "10          4630       1775        1480           1770               1265   \n",
       "11          4567       1786        1456           1700               1195   \n",
       "12          4319       1785        1441           1885               1435   \n",
       "13          4661       1898        1664           2360               1860   \n",
       "14          4590       1820        1488           1736               1320   \n",
       "15          4530       1900        1700           1860               1485   \n",
       "16          5055       1695        1960           2160               1560   \n",
       "17          4600       1780        1445           1720               1260   \n",
       "18          4631       1760        1503           1650               1236   \n",
       "19          4270       1772        1605           1775               1205   \n",
       "20          5266       1878        1772           2470               1930   \n",
       "21          4649       1852        1710           2059               1560   \n",
       "22          4570       1775        1445           1608               1233   \n",
       "23          4872       1834        1484           2120               1600   \n",
       "24          4620       1820        1750           1780               1410   \n",
       "25          4558       1805        1505           1798               1370   \n",
       "26          4368       1823        1483           1707               1332   \n",
       "27          4605       1765        1460           1775               1265   \n",
       "28          4524       1838        1695           2092               1717   \n",
       "29          4270       1772        1605           1775               1304   \n",
       "...          ...        ...         ...            ...                ...   \n",
       "20127       4872       1834        1484           2015               1495   \n",
       "20128       4370       1700        1460           1500               1085   \n",
       "20129       4294       1772        1605           1770               1204   \n",
       "20130       4255       1799        1452           1740               1260   \n",
       "20131       4649       1852        1710           2106               1620   \n",
       "20132       4868       1830        1490           1900               1469   \n",
       "20133       4930       1845        1470           1920               1495   \n",
       "20134       4160       1810        1635           1645               1270   \n",
       "20135       4510       1797        1477           1893               1485   \n",
       "20136       4480       1855        1645           2090               1525   \n",
       "20137       4282       1706        1475           1635               1155   \n",
       "20138       4500       1721        1715           1825               1260   \n",
       "20139       4280       1785        1658           1670               1295   \n",
       "20140       4587       1798        1463           1660               1225   \n",
       "20141       4562       1793        1468           1700               1220   \n",
       "20142       4755       1811        1455           1980               1560   \n",
       "20143       5055       1860        1491           2250               1790   \n",
       "20144       5266       1878        1772           2470               1860   \n",
       "20145       4680       1800        1750           1975               1450   \n",
       "20146       4335       1814        1695           1895               1520   \n",
       "20147       4280       1785        1658           1620               1245   \n",
       "20148       4585       1820        1685           2010               1540   \n",
       "20149       4567       1786        1456           1700               1225   \n",
       "20150       4865       1820        1475           2000               1545   \n",
       "20151       4600       1780        1445           1700               1210   \n",
       "20152       4282       1706        1475           1600               1120   \n",
       "20153       4473       1706        1469           1635               1155   \n",
       "20154       4805       1860        1458           2065               1580   \n",
       "20155       4294       1772        1605           1770               1302   \n",
       "20156       4370       1700        1460           1500               1083   \n",
       "\n",
       "       rated_passenger  wheelbase  front_track  rear_track  \n",
       "0                    5       2700         1556        1562  \n",
       "1                    5       2648         1553        1544  \n",
       "2                    5       2770         1579        1589  \n",
       "3                    5       2603         1460        1500  \n",
       "4                    5       2720         1420        1440  \n",
       "5                    5       2620         1580        1580  \n",
       "6                    5       2650         1575        1570  \n",
       "7                    5       2650         1502        1492  \n",
       "8                    5       2560         1525        1520  \n",
       "9                    5       2857         1645        1645  \n",
       "10                   5       2700         1535        1535  \n",
       "11                   5       2662         1540        1558  \n",
       "12                   5       2629         1539        1509  \n",
       "13                   5       2873         1617        1613  \n",
       "14                   5       2675         1555        1550  \n",
       "15                   5       2700         1601        1602  \n",
       "16                 7-8       3000         1445        1420  \n",
       "17                   5       2700         1555        1568  \n",
       "18                   5       2700         1540        1540  \n",
       "19                   5       2610         1540        1530  \n",
       "20                   7       3088         1593        1603  \n",
       "21                   5       2680         1565        1565  \n",
       "22                   5       2700         1549        1562  \n",
       "23                   5       2803         1577        1550  \n",
       "24                   5       2750         1554        1549  \n",
       "25                   5       2612         1525        1522  \n",
       "26                   5       2648         1553        1544  \n",
       "27                   5       2610         1517        1493  \n",
       "28                   5       2690         1563        1565  \n",
       "29                   5       2610         1540        1530  \n",
       "...                ...        ...          ...         ...  \n",
       "20127                5       2803         1577        1550  \n",
       "20128                5       2570         1511        1515  \n",
       "20129                5       2610         1535        1540  \n",
       "20130                5       2637         1549        1520  \n",
       "20131                5       2680         1565        1565  \n",
       "20132                5       2775         1585        1585  \n",
       "20133                5       2775         1595        1585  \n",
       "20134                5       2560         1560        1560  \n",
       "20135                5       2685         1535        1557  \n",
       "20136                5       2670         1625        1636  \n",
       "20137                5       2603         1460        1500  \n",
       "20138              7-8       2720         1430        1450  \n",
       "20139                5       2530         1527        1533  \n",
       "20140                5       2640         1538        1541  \n",
       "20141                5       2614         1518        1525  \n",
       "20142                5       2920         1531        1572  \n",
       "20143                5       3108         1600        1627  \n",
       "20144                7       3088         1593        1603  \n",
       "20145                7       2780         1495        1505  \n",
       "20146                5       2560         1525        1520  \n",
       "20147                5       2530         1527        1533  \n",
       "20148                5       2620         1580        1580  \n",
       "20149                5       2662         1540        1558  \n",
       "20150              4-5       2812         1552        1551  \n",
       "20151                5       2700         1555        1568  \n",
       "20152                5       2603         1460        1500  \n",
       "20153                5       2603         1460        1500  \n",
       "20154                5       2815         1584        1551  \n",
       "20155                5       2610         1535        1540  \n",
       "20156                5       2570         1511        1515  \n",
       "\n",
       "[20157 rows x 32 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 将level_id字段中的-替换为np.nan\n",
    "df = pd.read_csv('../../data/origin/[new] yancheng_train_20171226.csv', dtype={'sale_date':str}, na_values=['-'], low_memory=False)\n",
    "df['sale_date']= pd.to_datetime(df['sale_date'], format='%Y%m')\n",
    "\n",
    "# 将price_level字段转换成有序类别的类型，并用其数值填入该列。\n",
    "df['price_level'] = df['price_level'].astype('category', categories=['5WL','5-8W','8-10W','10-15W','15-20W','20-25W','25-35W','35-50W','50-75W'], ordered=True)\n",
    "df['price_level'] = df['price_level'].cat.codes\n",
    "\n",
    "# 待选方案：先把power和扭矩字段带/的行复制一份，然后将新行里的销量清零，将原行和新行的power和扭矩字段的值分别赋为slash前后的值。\n",
    "# 现行方案：先他娘的直接把slash和后面的值删掉。省得影响记录条数相关的统计量。\n",
    "def process_power_and_torque(s):\n",
    "    return s.split('/')[0]\n",
    "df['power'] = df['power'].astype(str).apply(process_power_and_torque).astype(float) #[18600]\n",
    "df['engine_torque'] = df['engine_torque'].astype(str).apply(process_power_and_torque).astype(float)\n",
    "\n",
    "# # -------------------------------------------------------------\n",
    "# # 把2017年11月的数据拼进来，一块填入其特征，用于最终输出要提交的结果。\n",
    "# empty_Nov = pd.read_csv('../../data/origin/yancheng_testA_20171225.csv', dtype={'predict_date':str}, na_values=['-'], low_memory=False)\n",
    "# empty_Nov['predict_date']= pd.to_datetime(empty_Nov['predict_date'], format='%Y%m')\n",
    "# empty_Nov.rename(columns = {'predict_date': 'sale_date', 'predict_quantity':'sale_quantity'}, inplace = True)\n",
    "\n",
    "\n",
    "# # 读取玩了，先不急着拼，先把车型到品牌的映射关系join进来\n",
    "# class_to_brand = df[['class_id','brand_id']].groupby(['class_id']).mean().reset_index()\n",
    "# empyt_Nov = pd.merge(left=empty_Nov, right=class_to_brand, on='class_id', how='left')\n",
    "# empty_Nov['brand_id']= class_to_brand['brand_id']\n",
    "# # empty_Nov\n",
    "# # class_to_brand\n",
    "\n",
    "# # class_to_brand\n",
    "\n",
    "# # 读取完了，拼上去\n",
    "# df = pd.concat([df, empty_Nov])\n",
    "# df.info()\n",
    "\n",
    "# ------------------------------------------------------------------\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "class_id  sale_date \n",
       "103507    2015-03-01      58\n",
       "          2015-04-01     232\n",
       "          2015-05-01     226\n",
       "          2015-06-01     286\n",
       "          2015-07-01     297\n",
       "          2015-08-01     355\n",
       "          2015-09-01     442\n",
       "          2015-10-01    1050\n",
       "          2015-11-01     481\n",
       "          2015-12-01    1433\n",
       "          2016-01-01     993\n",
       "          2016-02-01     953\n",
       "          2016-03-01     650\n",
       "          2016-04-01     145\n",
       "          2016-05-01     772\n",
       "          2016-06-01     829\n",
       "          2016-07-01     378\n",
       "          2016-08-01     406\n",
       "          2016-09-01     684\n",
       "          2016-10-01     632\n",
       "          2016-11-01     876\n",
       "          2016-12-01    1653\n",
       "          2017-01-01     499\n",
       "          2017-02-01     435\n",
       "          2017-03-01     371\n",
       "          2017-04-01     290\n",
       "          2017-05-01     429\n",
       "          2017-06-01     371\n",
       "          2017-07-01     313\n",
       "          2017-08-01     180\n",
       "                        ... \n",
       "978089    2015-05-01     418\n",
       "          2015-06-01     372\n",
       "          2015-07-01     428\n",
       "          2015-08-01     503\n",
       "          2015-09-01     753\n",
       "          2015-10-01     790\n",
       "          2015-11-01     659\n",
       "          2015-12-01    1284\n",
       "          2016-01-01     651\n",
       "          2016-02-01     623\n",
       "          2016-03-01     605\n",
       "          2016-04-01     604\n",
       "          2016-05-01     735\n",
       "          2016-06-01     474\n",
       "          2016-07-01     530\n",
       "          2016-08-01     521\n",
       "          2016-09-01     474\n",
       "          2016-10-01     503\n",
       "          2016-11-01     400\n",
       "          2016-12-01    1042\n",
       "          2017-01-01     558\n",
       "          2017-02-01     494\n",
       "          2017-03-01     548\n",
       "          2017-04-01     466\n",
       "          2017-05-01     512\n",
       "          2017-06-01     381\n",
       "          2017-07-01     270\n",
       "          2017-08-01     419\n",
       "          2017-09-01     401\n",
       "          2017-10-01     400\n",
       "Name: sale_quantity, Length: 5587, dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gs = df.groupby(['class_id','sale_date'])['sale_quantity'].sum()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "class_id\n",
       "103507    32\n",
       "124140    42\n",
       "125403    70\n",
       "136916    70\n",
       "169673     5\n",
       "175962    59\n",
       "178529    70\n",
       "186250    21\n",
       "194201     2\n",
       "194450    69\n",
       "198427    53\n",
       "206765    28\n",
       "209945    70\n",
       "219195    39\n",
       "221795    55\n",
       "245609    19\n",
       "248352    70\n",
       "249875    12\n",
       "250658    20\n",
       "265980    69\n",
       "270690    34\n",
       "281301    70\n",
       "281792    41\n",
       "289386    41\n",
       "289403    18\n",
       "290854    70\n",
       "291086    70\n",
       "291514    60\n",
       "302513    12\n",
       "304458    70\n",
       "          ..\n",
       "745137    66\n",
       "750340    28\n",
       "760412    10\n",
       "786351    62\n",
       "789290     8\n",
       "810398    27\n",
       "815230    10\n",
       "819061    70\n",
       "842246     5\n",
       "851857    19\n",
       "854079    52\n",
       "854548     8\n",
       "861459     8\n",
       "871642    54\n",
       "872180     4\n",
       "883691    70\n",
       "890189    10\n",
       "905061     4\n",
       "905745    60\n",
       "914348    70\n",
       "923841    68\n",
       "924154    34\n",
       "948936    13\n",
       "950264    16\n",
       "953842    21\n",
       "961362    70\n",
       "961962    70\n",
       "963845    37\n",
       "973106    12\n",
       "978089    39\n",
       "Length: 140, dtype: int64"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 统计每个月有多少个车型在售\n",
    "selling_cls_in_month = df[['sale_date', 'class_id']].groupby(['sale_date', 'class_id']).size().unstack()\n",
    "selling_cls_in_month.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "ttt = df[['sale_date','class_id','sale_quantity']].groupby(['sale_date', 'class_id']).sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "ttt.unstack().to_csv('../../data/eda/各车型历史销量走势.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "sale_date\n",
       "2012-01-01    171\n",
       "2012-02-01    153\n",
       "2012-03-01    168\n",
       "2012-04-01    156\n",
       "2012-05-01    166\n",
       "2012-06-01    159\n",
       "2012-07-01    176\n",
       "2012-08-01    172\n",
       "2012-09-01    187\n",
       "2012-10-01    183\n",
       "2012-11-01    184\n",
       "2012-12-01    183\n",
       "2013-01-01    213\n",
       "2013-02-01    188\n",
       "2013-03-01    178\n",
       "2013-04-01    192\n",
       "2013-05-01    193\n",
       "2013-06-01    195\n",
       "2013-07-01    211\n",
       "2013-08-01    218\n",
       "2013-09-01    225\n",
       "2013-10-01    235\n",
       "2013-11-01    235\n",
       "2013-12-01    221\n",
       "2014-01-01    260\n",
       "2014-02-01    230\n",
       "2014-03-01    240\n",
       "2014-04-01    256\n",
       "2014-05-01    278\n",
       "2014-06-01    267\n",
       "             ... \n",
       "2015-05-01    352\n",
       "2015-06-01    350\n",
       "2015-07-01    349\n",
       "2015-08-01    350\n",
       "2015-09-01    375\n",
       "2015-10-01    370\n",
       "2015-11-01    383\n",
       "2015-12-01    384\n",
       "2016-01-01    378\n",
       "2016-02-01    356\n",
       "2016-03-01    369\n",
       "2016-04-01    337\n",
       "2016-05-01    300\n",
       "2016-06-01    304\n",
       "2016-07-01    305\n",
       "2016-08-01    312\n",
       "2016-09-01    331\n",
       "2016-10-01    354\n",
       "2016-11-01    368\n",
       "2016-12-01    387\n",
       "2017-01-01    369\n",
       "2017-02-01    351\n",
       "2017-03-01    384\n",
       "2017-04-01    373\n",
       "2017-05-01    386\n",
       "2017-06-01    387\n",
       "2017-07-01    389\n",
       "2017-08-01    400\n",
       "2017-09-01    406\n",
       "2017-10-01    207\n",
       "Name: class_id, Length: 70, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cls_in_month = df.groupby('sale_date')['class_id'].count()\n",
    "cls_in_month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       AT\n",
       "1       AT\n",
       "2       AT\n",
       "3       AT\n",
       "4       MT\n",
       "5       MT\n",
       "6       MT\n",
       "7       AT\n",
       "8       AT\n",
       "9      DCT\n",
       "10      MT\n",
       "11      AT\n",
       "12      AT\n",
       "13      MT\n",
       "14     DCT\n",
       "15     DCT\n",
       "16      AT\n",
       "17     CVT\n",
       "18     DCT\n",
       "19      MT\n",
       "20      MT\n",
       "21     DCT\n",
       "22     DCT\n",
       "23      AT\n",
       "24     DCT\n",
       "25      AT\n",
       "26      AT\n",
       "27      MT\n",
       "28      MT\n",
       "29     CVT\n",
       "      ... \n",
       "110    DCT\n",
       "111     AT\n",
       "112    CVT\n",
       "113     AT\n",
       "114    CVT\n",
       "115     AT\n",
       "116    DCT\n",
       "117     AT\n",
       "118    DCT\n",
       "119     AT\n",
       "120     AT\n",
       "121     AT\n",
       "122    DCT\n",
       "123     AT\n",
       "124    DCT\n",
       "125    DCT\n",
       "126     MT\n",
       "127     MT\n",
       "128     AT\n",
       "129     AT\n",
       "130     AT\n",
       "131     AT\n",
       "132     MT\n",
       "133    DCT\n",
       "134    DCT\n",
       "135    CVT\n",
       "136     MT\n",
       "137     AT\n",
       "138    CVT\n",
       "139     MT\n",
       "Name: gearbox_type, Length: 140, dtype: object"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "gd = df.groupby(['class_id','gearbox_type']).sum().sort_values(ascending=False, by=['sale_quantity']).reset_index()\n",
    "# gd[gd['if_MPV_id']==1]\n",
    "gd.groupby('class_id').first().reset_index()['gearbox_type']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>class_id</th>\n",
       "      <th>brand_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>103507</td>\n",
       "      <td>831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>124140</td>\n",
       "      <td>783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>125403</td>\n",
       "      <td>761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>136916</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>169673</td>\n",
       "      <td>682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>175962</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>178529</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>186250</td>\n",
       "      <td>761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>194201</td>\n",
       "      <td>831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>194450</td>\n",
       "      <td>836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>198427</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>206765</td>\n",
       "      <td>761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>209945</td>\n",
       "      <td>814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>219195</td>\n",
       "      <td>638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>221795</td>\n",
       "      <td>872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>245609</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>248352</td>\n",
       "      <td>831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>249875</td>\n",
       "      <td>294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>250658</td>\n",
       "      <td>450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>265980</td>\n",
       "      <td>783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>270690</td>\n",
       "      <td>98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>281301</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>281792</td>\n",
       "      <td>872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>289386</td>\n",
       "      <td>813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>289403</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>290854</td>\n",
       "      <td>537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>291086</td>\n",
       "      <td>761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>291514</td>\n",
       "      <td>783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>302513</td>\n",
       "      <td>864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>304458</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>745137</td>\n",
       "      <td>637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>750340</td>\n",
       "      <td>864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>760412</td>\n",
       "      <td>542</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>786351</td>\n",
       "      <td>836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>789290</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>810398</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>815230</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>819061</td>\n",
       "      <td>831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>842246</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>851857</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>854079</td>\n",
       "      <td>537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>854548</td>\n",
       "      <td>126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>861459</td>\n",
       "      <td>498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>871642</td>\n",
       "      <td>637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>872180</td>\n",
       "      <td>76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>883691</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>890189</td>\n",
       "      <td>290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>905061</td>\n",
       "      <td>783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>905745</td>\n",
       "      <td>761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>914348</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>923841</td>\n",
       "      <td>450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>924154</td>\n",
       "      <td>637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>948936</td>\n",
       "      <td>512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>950264</td>\n",
       "      <td>498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>953842</td>\n",
       "      <td>831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>961362</td>\n",
       "      <td>692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>961962</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>963845</td>\n",
       "      <td>836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>973106</td>\n",
       "      <td>537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>978089</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>140 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     class_id  brand_id\n",
       "0      103507       831\n",
       "1      124140       783\n",
       "2      125403       761\n",
       "3      136916       106\n",
       "4      169673       682\n",
       "5      175962       750\n",
       "6      178529        98\n",
       "7      186250       761\n",
       "8      194201       831\n",
       "9      194450       836\n",
       "10     198427        12\n",
       "11     206765       761\n",
       "12     209945       814\n",
       "13     219195       638\n",
       "14     221795       872\n",
       "15     245609       750\n",
       "16     248352       831\n",
       "17     249875       294\n",
       "18     250658       450\n",
       "19     265980       783\n",
       "20     270690        98\n",
       "21     281301       750\n",
       "22     281792       872\n",
       "23     289386       813\n",
       "24     289403        12\n",
       "25     290854       537\n",
       "26     291086       761\n",
       "27     291514       783\n",
       "28     302513       864\n",
       "29     304458       106\n",
       "..        ...       ...\n",
       "110    745137       637\n",
       "111    750340       864\n",
       "112    760412       542\n",
       "113    786351       836\n",
       "114    789290       106\n",
       "115    810398       750\n",
       "116    815230        49\n",
       "117    819061       831\n",
       "118    842246        68\n",
       "119    851857        75\n",
       "120    854079       537\n",
       "121    854548       126\n",
       "122    861459       498\n",
       "123    871642       637\n",
       "124    872180        76\n",
       "125    883691       750\n",
       "126    890189       290\n",
       "127    905061       783\n",
       "128    905745       761\n",
       "129    914348       750\n",
       "130    923841       450\n",
       "131    924154       637\n",
       "132    948936       512\n",
       "133    950264       498\n",
       "134    953842       831\n",
       "135    961362       692\n",
       "136    961962       750\n",
       "137    963845       836\n",
       "138    973106       537\n",
       "139    978089        12\n",
       "\n",
       "[140 rows x 2 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "modes = df[['class_id','brand_id']].groupby('class_id').first().reset_index()\n",
    "modes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>class_id</th>\n",
       "      <th>brand_id</th>\n",
       "      <th>compartment</th>\n",
       "      <th>type_id</th>\n",
       "      <th>level_id</th>\n",
       "      <th>department_id</th>\n",
       "      <th>TR</th>\n",
       "      <th>gearbox_type</th>\n",
       "      <th>displacement</th>\n",
       "      <th>if_charging</th>\n",
       "      <th>...</th>\n",
       "      <th>engine_torque</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>total_quality</th>\n",
       "      <th>equipment_quality</th>\n",
       "      <th>rated_passenger</th>\n",
       "      <th>wheelbase</th>\n",
       "      <th>front_track</th>\n",
       "      <th>rear_track</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>103507</td>\n",
       "      <td>831</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>150.7</td>\n",
       "      <td>4270</td>\n",
       "      <td>1780</td>\n",
       "      <td>1630</td>\n",
       "      <td>1830</td>\n",
       "      <td>1325</td>\n",
       "      <td>5</td>\n",
       "      <td>2590</td>\n",
       "      <td>1557</td>\n",
       "      <td>1570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>124140</td>\n",
       "      <td>783</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.8</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>230.0</td>\n",
       "      <td>4650</td>\n",
       "      <td>1850</td>\n",
       "      <td>1695</td>\n",
       "      <td>2075</td>\n",
       "      <td>1665</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1565</td>\n",
       "      <td>1565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>125403</td>\n",
       "      <td>761</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>2.4</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>225.0</td>\n",
       "      <td>5213</td>\n",
       "      <td>1878</td>\n",
       "      <td>1772</td>\n",
       "      <td>2470</td>\n",
       "      <td>1840</td>\n",
       "      <td>7</td>\n",
       "      <td>3088</td>\n",
       "      <td>1593</td>\n",
       "      <td>1601</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>136916</td>\n",
       "      <td>106</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>AT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4825</td>\n",
       "      <td>1825</td>\n",
       "      <td>1480</td>\n",
       "      <td>2000</td>\n",
       "      <td>1465</td>\n",
       "      <td>5</td>\n",
       "      <td>2775</td>\n",
       "      <td>1575</td>\n",
       "      <td>1560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>169673</td>\n",
       "      <td>682</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>215.0</td>\n",
       "      <td>4715</td>\n",
       "      <td>1830</td>\n",
       "      <td>1780</td>\n",
       "      <td>2095</td>\n",
       "      <td>1570</td>\n",
       "      <td>7</td>\n",
       "      <td>2760</td>\n",
       "      <td>1547</td>\n",
       "      <td>1550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>175962</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4473</td>\n",
       "      <td>1706</td>\n",
       "      <td>1469</td>\n",
       "      <td>1600</td>\n",
       "      <td>1120</td>\n",
       "      <td>5</td>\n",
       "      <td>2603</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>178529</td>\n",
       "      <td>98</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>85.0</td>\n",
       "      <td>3730</td>\n",
       "      <td>1510</td>\n",
       "      <td>1860</td>\n",
       "      <td>1575</td>\n",
       "      <td>985</td>\n",
       "      <td>7</td>\n",
       "      <td>2500</td>\n",
       "      <td>1290</td>\n",
       "      <td>1290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>186250</td>\n",
       "      <td>761</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>146.0</td>\n",
       "      <td>4370</td>\n",
       "      <td>1809</td>\n",
       "      <td>1461</td>\n",
       "      <td>1715</td>\n",
       "      <td>1280</td>\n",
       "      <td>5</td>\n",
       "      <td>2662</td>\n",
       "      <td>1540</td>\n",
       "      <td>1562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>194201</td>\n",
       "      <td>831</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.4</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>132.4</td>\n",
       "      <td>4240</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1570</td>\n",
       "      <td>1145</td>\n",
       "      <td>5</td>\n",
       "      <td>2600</td>\n",
       "      <td>1524</td>\n",
       "      <td>1529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>194450</td>\n",
       "      <td>836</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>265.0</td>\n",
       "      <td>4475</td>\n",
       "      <td>1850</td>\n",
       "      <td>1655</td>\n",
       "      <td>2090</td>\n",
       "      <td>1541</td>\n",
       "      <td>5</td>\n",
       "      <td>2670</td>\n",
       "      <td>1620</td>\n",
       "      <td>1631</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>198427</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4547</td>\n",
       "      <td>1734</td>\n",
       "      <td>1470</td>\n",
       "      <td>1620</td>\n",
       "      <td>1210</td>\n",
       "      <td>5</td>\n",
       "      <td>2600</td>\n",
       "      <td>1490</td>\n",
       "      <td>1470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>206765</td>\n",
       "      <td>761</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>146.0</td>\n",
       "      <td>4718</td>\n",
       "      <td>1802</td>\n",
       "      <td>1466</td>\n",
       "      <td>1745</td>\n",
       "      <td>1295</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1540</td>\n",
       "      <td>1558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>209945</td>\n",
       "      <td>814</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>AT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>310.0</td>\n",
       "      <td>5055</td>\n",
       "      <td>1860</td>\n",
       "      <td>1491</td>\n",
       "      <td>2250</td>\n",
       "      <td>1790</td>\n",
       "      <td>5</td>\n",
       "      <td>3108</td>\n",
       "      <td>1600</td>\n",
       "      <td>1627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>219195</td>\n",
       "      <td>638</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>210.0</td>\n",
       "      <td>4335</td>\n",
       "      <td>1814</td>\n",
       "      <td>1695</td>\n",
       "      <td>1910</td>\n",
       "      <td>1495</td>\n",
       "      <td>5</td>\n",
       "      <td>2560</td>\n",
       "      <td>1525</td>\n",
       "      <td>1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>221795</td>\n",
       "      <td>872</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.4</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4385</td>\n",
       "      <td>1831</td>\n",
       "      <td>1589</td>\n",
       "      <td>2020</td>\n",
       "      <td>1500</td>\n",
       "      <td>5</td>\n",
       "      <td>2603</td>\n",
       "      <td>1571</td>\n",
       "      <td>1575</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>245609</td>\n",
       "      <td>750</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.4</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>225.0</td>\n",
       "      <td>4348</td>\n",
       "      <td>1807</td>\n",
       "      <td>1574</td>\n",
       "      <td>1880</td>\n",
       "      <td>1425</td>\n",
       "      <td>5</td>\n",
       "      <td>2680</td>\n",
       "      <td>1549</td>\n",
       "      <td>1521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>248352</td>\n",
       "      <td>831</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.4</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>135.0</td>\n",
       "      <td>4370</td>\n",
       "      <td>1700</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "      <td>1039</td>\n",
       "      <td>5</td>\n",
       "      <td>2570</td>\n",
       "      <td>1511</td>\n",
       "      <td>1515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>249875</td>\n",
       "      <td>294</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>200.0</td>\n",
       "      <td>4672</td>\n",
       "      <td>1843</td>\n",
       "      <td>1678</td>\n",
       "      <td>2004</td>\n",
       "      <td>1557</td>\n",
       "      <td>5</td>\n",
       "      <td>2705</td>\n",
       "      <td>1597</td>\n",
       "      <td>1589</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>250658</td>\n",
       "      <td>450</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>252.0</td>\n",
       "      <td>4923</td>\n",
       "      <td>1854</td>\n",
       "      <td>1470</td>\n",
       "      <td>1865</td>\n",
       "      <td>1415</td>\n",
       "      <td>5</td>\n",
       "      <td>2829</td>\n",
       "      <td>1606</td>\n",
       "      <td>1609</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>265980</td>\n",
       "      <td>783</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>135.0</td>\n",
       "      <td>4360</td>\n",
       "      <td>1685</td>\n",
       "      <td>1820</td>\n",
       "      <td>1925</td>\n",
       "      <td>1325</td>\n",
       "      <td>7-8</td>\n",
       "      <td>2750</td>\n",
       "      <td>1425</td>\n",
       "      <td>1435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>270690</td>\n",
       "      <td>98</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>146.5</td>\n",
       "      <td>4415</td>\n",
       "      <td>1685</td>\n",
       "      <td>1850</td>\n",
       "      <td>1825</td>\n",
       "      <td>1256</td>\n",
       "      <td>5</td>\n",
       "      <td>2720</td>\n",
       "      <td>1420</td>\n",
       "      <td>1440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>281301</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.8</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4870</td>\n",
       "      <td>1834</td>\n",
       "      <td>1472</td>\n",
       "      <td>2060</td>\n",
       "      <td>1520</td>\n",
       "      <td>5</td>\n",
       "      <td>2803</td>\n",
       "      <td>1577</td>\n",
       "      <td>1550</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>281792</td>\n",
       "      <td>872</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.4</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4462</td>\n",
       "      <td>1796</td>\n",
       "      <td>1421</td>\n",
       "      <td>1795</td>\n",
       "      <td>1345</td>\n",
       "      <td>5</td>\n",
       "      <td>2629</td>\n",
       "      <td>1552</td>\n",
       "      <td>1520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>289386</td>\n",
       "      <td>813</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>148.0</td>\n",
       "      <td>4582</td>\n",
       "      <td>1795</td>\n",
       "      <td>1458</td>\n",
       "      <td>1820</td>\n",
       "      <td>1286</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1555</td>\n",
       "      <td>1560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>289403</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.3</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>185.0</td>\n",
       "      <td>4440</td>\n",
       "      <td>1833</td>\n",
       "      <td>1545</td>\n",
       "      <td>1773</td>\n",
       "      <td>1398</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1556</td>\n",
       "      <td>1562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>290854</td>\n",
       "      <td>537</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>AT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4550</td>\n",
       "      <td>1820</td>\n",
       "      <td>1685</td>\n",
       "      <td>2010</td>\n",
       "      <td>1625</td>\n",
       "      <td>5</td>\n",
       "      <td>2620</td>\n",
       "      <td>1565</td>\n",
       "      <td>1565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>291086</td>\n",
       "      <td>761</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>190.0</td>\n",
       "      <td>4843</td>\n",
       "      <td>1856</td>\n",
       "      <td>1484</td>\n",
       "      <td>2020</td>\n",
       "      <td>1585</td>\n",
       "      <td>5</td>\n",
       "      <td>2737</td>\n",
       "      <td>1585</td>\n",
       "      <td>1588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>291514</td>\n",
       "      <td>783</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>160.0</td>\n",
       "      <td>4160</td>\n",
       "      <td>1810</td>\n",
       "      <td>1635</td>\n",
       "      <td>1645</td>\n",
       "      <td>1270</td>\n",
       "      <td>5</td>\n",
       "      <td>2560</td>\n",
       "      <td>1560</td>\n",
       "      <td>1560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>302513</td>\n",
       "      <td>864</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>143.0</td>\n",
       "      <td>4354</td>\n",
       "      <td>1840</td>\n",
       "      <td>1654</td>\n",
       "      <td>1670</td>\n",
       "      <td>1285</td>\n",
       "      <td>5</td>\n",
       "      <td>2610</td>\n",
       "      <td>1585</td>\n",
       "      <td>1586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>304458</td>\n",
       "      <td>106</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>154.0</td>\n",
       "      <td>4630</td>\n",
       "      <td>1775</td>\n",
       "      <td>1480</td>\n",
       "      <td>1770</td>\n",
       "      <td>1305</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1535</td>\n",
       "      <td>1535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>745137</td>\n",
       "      <td>637</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>215.0</td>\n",
       "      <td>4534</td>\n",
       "      <td>1823</td>\n",
       "      <td>1483</td>\n",
       "      <td>1712</td>\n",
       "      <td>1337</td>\n",
       "      <td>5</td>\n",
       "      <td>2648</td>\n",
       "      <td>1553</td>\n",
       "      <td>1544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>750340</td>\n",
       "      <td>864</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>201.0</td>\n",
       "      <td>4530</td>\n",
       "      <td>1900</td>\n",
       "      <td>1700</td>\n",
       "      <td>1920</td>\n",
       "      <td>1545</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1601</td>\n",
       "      <td>1602</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>760412</td>\n",
       "      <td>542</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>155.5</td>\n",
       "      <td>4705</td>\n",
       "      <td>1810</td>\n",
       "      <td>1680</td>\n",
       "      <td>1985</td>\n",
       "      <td>1440</td>\n",
       "      <td>5</td>\n",
       "      <td>2670</td>\n",
       "      <td>1540</td>\n",
       "      <td>1540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>786351</td>\n",
       "      <td>836</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4570</td>\n",
       "      <td>1775</td>\n",
       "      <td>1445</td>\n",
       "      <td>1642</td>\n",
       "      <td>1267</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1549</td>\n",
       "      <td>1562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>789290</td>\n",
       "      <td>106</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4440</td>\n",
       "      <td>1700</td>\n",
       "      <td>1490</td>\n",
       "      <td>1500</td>\n",
       "      <td>1090</td>\n",
       "      <td>5</td>\n",
       "      <td>2550</td>\n",
       "      <td>1460</td>\n",
       "      <td>1460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>810398</td>\n",
       "      <td>750</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4282</td>\n",
       "      <td>1706</td>\n",
       "      <td>1475</td>\n",
       "      <td>1635</td>\n",
       "      <td>1155</td>\n",
       "      <td>5</td>\n",
       "      <td>2603</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>815230</td>\n",
       "      <td>49</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.4</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>199.0</td>\n",
       "      <td>4415</td>\n",
       "      <td>1819</td>\n",
       "      <td>1625</td>\n",
       "      <td>1830</td>\n",
       "      <td>1455</td>\n",
       "      <td>5</td>\n",
       "      <td>2636</td>\n",
       "      <td>1544</td>\n",
       "      <td>1544</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>819061</td>\n",
       "      <td>831</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>245.0</td>\n",
       "      <td>4450</td>\n",
       "      <td>1855</td>\n",
       "      <td>1635</td>\n",
       "      <td>1980</td>\n",
       "      <td>1470</td>\n",
       "      <td>5</td>\n",
       "      <td>2640</td>\n",
       "      <td>1614</td>\n",
       "      <td>1615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>842246</td>\n",
       "      <td>68</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.8</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>400.0</td>\n",
       "      <td>4748</td>\n",
       "      <td>1933</td>\n",
       "      <td>1697</td>\n",
       "      <td>2162</td>\n",
       "      <td>1787</td>\n",
       "      <td>5</td>\n",
       "      <td>2850</td>\n",
       "      <td>1641</td>\n",
       "      <td>1642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>851857</td>\n",
       "      <td>75</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>AT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>172.0</td>\n",
       "      <td>4812</td>\n",
       "      <td>1903</td>\n",
       "      <td>1680</td>\n",
       "      <td>2275</td>\n",
       "      <td>1795</td>\n",
       "      <td>5</td>\n",
       "      <td>2857</td>\n",
       "      <td>1645</td>\n",
       "      <td>1645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>854079</td>\n",
       "      <td>537</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.8</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>150.0</td>\n",
       "      <td>4650</td>\n",
       "      <td>1750</td>\n",
       "      <td>1505</td>\n",
       "      <td>1650</td>\n",
       "      <td>1275</td>\n",
       "      <td>5</td>\n",
       "      <td>2650</td>\n",
       "      <td>1500</td>\n",
       "      <td>1485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>854548</td>\n",
       "      <td>126</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4314</td>\n",
       "      <td>1809</td>\n",
       "      <td>1624</td>\n",
       "      <td>1690</td>\n",
       "      <td>1258</td>\n",
       "      <td>5</td>\n",
       "      <td>2585</td>\n",
       "      <td>1526</td>\n",
       "      <td>1536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>861459</td>\n",
       "      <td>498</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>240.0</td>\n",
       "      <td>4671</td>\n",
       "      <td>1835</td>\n",
       "      <td>1464</td>\n",
       "      <td>1720</td>\n",
       "      <td>1270</td>\n",
       "      <td>5</td>\n",
       "      <td>2715</td>\n",
       "      <td>1562</td>\n",
       "      <td>1571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>871642</td>\n",
       "      <td>637</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>360.0</td>\n",
       "      <td>4524</td>\n",
       "      <td>1838</td>\n",
       "      <td>1685</td>\n",
       "      <td>1967</td>\n",
       "      <td>1592</td>\n",
       "      <td>5</td>\n",
       "      <td>2690</td>\n",
       "      <td>1563</td>\n",
       "      <td>1565</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>872180</td>\n",
       "      <td>76</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4765</td>\n",
       "      <td>1931</td>\n",
       "      <td>1655</td>\n",
       "      <td>2505</td>\n",
       "      <td>1960</td>\n",
       "      <td>5</td>\n",
       "      <td>2950</td>\n",
       "      <td>1655</td>\n",
       "      <td>1606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>883691</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.8</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>146.5</td>\n",
       "      <td>4865</td>\n",
       "      <td>1820</td>\n",
       "      <td>1475</td>\n",
       "      <td>2000</td>\n",
       "      <td>1545</td>\n",
       "      <td>5</td>\n",
       "      <td>2812</td>\n",
       "      <td>1552</td>\n",
       "      <td>1551</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>890189</td>\n",
       "      <td>290</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>160.0</td>\n",
       "      <td>4220</td>\n",
       "      <td>1740</td>\n",
       "      <td>1625</td>\n",
       "      <td>1580</td>\n",
       "      <td>1206</td>\n",
       "      <td>5</td>\n",
       "      <td>2550</td>\n",
       "      <td>1490</td>\n",
       "      <td>1496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>905061</td>\n",
       "      <td>783</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>200.0</td>\n",
       "      <td>4810</td>\n",
       "      <td>1795</td>\n",
       "      <td>1730</td>\n",
       "      <td>1950</td>\n",
       "      <td>1460</td>\n",
       "      <td>7</td>\n",
       "      <td>2760</td>\n",
       "      <td>1535</td>\n",
       "      <td>1530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>905745</td>\n",
       "      <td>761</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.4</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4278</td>\n",
       "      <td>1774</td>\n",
       "      <td>1646</td>\n",
       "      <td>1840</td>\n",
       "      <td>1430</td>\n",
       "      <td>5</td>\n",
       "      <td>2555</td>\n",
       "      <td>1540</td>\n",
       "      <td>1540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>914348</td>\n",
       "      <td>750</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>190.0</td>\n",
       "      <td>3970</td>\n",
       "      <td>1682</td>\n",
       "      <td>1462</td>\n",
       "      <td>1600</td>\n",
       "      <td>1120</td>\n",
       "      <td>5</td>\n",
       "      <td>2470</td>\n",
       "      <td>1463</td>\n",
       "      <td>1456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>923841</td>\n",
       "      <td>450</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>142.0</td>\n",
       "      <td>4869</td>\n",
       "      <td>1854</td>\n",
       "      <td>1472</td>\n",
       "      <td>1985</td>\n",
       "      <td>1565</td>\n",
       "      <td>5</td>\n",
       "      <td>2737</td>\n",
       "      <td>1585</td>\n",
       "      <td>1587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>924154</td>\n",
       "      <td>637</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>150.0</td>\n",
       "      <td>4587</td>\n",
       "      <td>1825</td>\n",
       "      <td>1490</td>\n",
       "      <td>1675</td>\n",
       "      <td>1300</td>\n",
       "      <td>5</td>\n",
       "      <td>2687</td>\n",
       "      <td>1562</td>\n",
       "      <td>1548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>948936</td>\n",
       "      <td>512</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>250.0</td>\n",
       "      <td>4520</td>\n",
       "      <td>1790</td>\n",
       "      <td>1750</td>\n",
       "      <td>1960</td>\n",
       "      <td>1435</td>\n",
       "      <td>6-7</td>\n",
       "      <td>2700</td>\n",
       "      <td>1450</td>\n",
       "      <td>1480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>950264</td>\n",
       "      <td>498</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>265.0</td>\n",
       "      <td>4545</td>\n",
       "      <td>1855</td>\n",
       "      <td>1690</td>\n",
       "      <td>1876</td>\n",
       "      <td>1501</td>\n",
       "      <td>5</td>\n",
       "      <td>2700</td>\n",
       "      <td>1574</td>\n",
       "      <td>1593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>953842</td>\n",
       "      <td>831</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>DCT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>198.0</td>\n",
       "      <td>4480</td>\n",
       "      <td>1855</td>\n",
       "      <td>1645</td>\n",
       "      <td>2090</td>\n",
       "      <td>1576</td>\n",
       "      <td>5</td>\n",
       "      <td>2670</td>\n",
       "      <td>1625</td>\n",
       "      <td>1636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>961362</td>\n",
       "      <td>692</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>2.0</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>160.0</td>\n",
       "      <td>4315</td>\n",
       "      <td>1783</td>\n",
       "      <td>1606</td>\n",
       "      <td>1930</td>\n",
       "      <td>1427</td>\n",
       "      <td>5</td>\n",
       "      <td>2630</td>\n",
       "      <td>1540</td>\n",
       "      <td>1545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>961962</td>\n",
       "      <td>750</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>150.7</td>\n",
       "      <td>4487</td>\n",
       "      <td>1706</td>\n",
       "      <td>1470</td>\n",
       "      <td>1600</td>\n",
       "      <td>1120</td>\n",
       "      <td>5</td>\n",
       "      <td>2603</td>\n",
       "      <td>1460</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>963845</td>\n",
       "      <td>836</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>AT</td>\n",
       "      <td>1.6</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>243.0</td>\n",
       "      <td>4270</td>\n",
       "      <td>1780</td>\n",
       "      <td>1622</td>\n",
       "      <td>1752</td>\n",
       "      <td>1341</td>\n",
       "      <td>5</td>\n",
       "      <td>2590</td>\n",
       "      <td>1557</td>\n",
       "      <td>1570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>973106</td>\n",
       "      <td>537</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>CVT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>T</td>\n",
       "      <td>...</td>\n",
       "      <td>140.0</td>\n",
       "      <td>4816</td>\n",
       "      <td>1942</td>\n",
       "      <td>1669</td>\n",
       "      <td>2180</td>\n",
       "      <td>1708</td>\n",
       "      <td>5</td>\n",
       "      <td>2820</td>\n",
       "      <td>1652</td>\n",
       "      <td>1671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>978089</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>MT</td>\n",
       "      <td>1.5</td>\n",
       "      <td>L</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4631</td>\n",
       "      <td>1789</td>\n",
       "      <td>1470</td>\n",
       "      <td>1625</td>\n",
       "      <td>1250</td>\n",
       "      <td>5</td>\n",
       "      <td>2650</td>\n",
       "      <td>1502</td>\n",
       "      <td>1492</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>140 rows × 30 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     class_id  brand_id  compartment  type_id  level_id  department_id TR  \\\n",
       "0      103507       831            2        1       3.0              3  6   \n",
       "1      124140       783            2        1       1.0              1  6   \n",
       "2      125403       761            2        3       2.0              2  6   \n",
       "3      136916       106            3        2       2.0              5  4   \n",
       "4      169673       682            2        1       2.0              1  6   \n",
       "5      175962       750            3        2       1.0              4  5   \n",
       "6      178529        98            1        4       1.0              1  5   \n",
       "7      186250       761            2        2       3.0              2  6   \n",
       "8      194201       831            2        2       1.0              3  6   \n",
       "9      194450       836            2        1       1.0              3  7   \n",
       "10     198427        12            3        2       1.0              1  5   \n",
       "11     206765       761            3        2       4.0              2  6   \n",
       "12     209945       814            3        2       3.0              4  8   \n",
       "13     219195       638            2        1       1.0              1  6   \n",
       "14     221795       872            2        1       1.0              4  6   \n",
       "15     245609       750            2        2       3.0              4  7   \n",
       "16     248352       831            3        2       1.0              3  4   \n",
       "17     249875       294            2        1       2.0              6  0   \n",
       "18     250658       450            3        2       3.0              2  7   \n",
       "19     265980       783            2        3       3.0              1  5   \n",
       "20     270690        98            2        3       2.0              1  5   \n",
       "21     281301       750            3        2       1.0              4  7   \n",
       "22     281792       872            3        2       1.0              4  7   \n",
       "23     289386       813            3        2       1.0              5  6   \n",
       "24     289403        12            2        1       1.0              1  6   \n",
       "25     290854       537            2        1       2.0              5  5   \n",
       "26     291086       761            3        2       3.0              2  6   \n",
       "27     291514       783            2        1       3.0              1  5   \n",
       "28     302513       864            2        1       1.0              1  5   \n",
       "29     304458       106            3        2       1.0              5  0   \n",
       "..        ...       ...          ...      ...       ...            ... ..   \n",
       "110    745137       637            3        2       1.0              2  6   \n",
       "111    750340       864            2        1       1.0              1  5   \n",
       "112    760412       542            2        1       1.0              5  0   \n",
       "113    786351       836            3        2       3.0              3  6   \n",
       "114    789290       106            3        2       1.0              5  0   \n",
       "115    810398       750            2        2       1.0              4  6   \n",
       "116    815230        49            2        1       1.0              2  7   \n",
       "117    819061       831            2        1       2.0              3  6   \n",
       "118    842246        68            2        1       2.0              1  6   \n",
       "119    851857        75            2        1       1.0              2  8   \n",
       "120    854079       537            3        2       3.0              5  5   \n",
       "121    854548       126            2        1       1.0              1  4   \n",
       "122    861459       498            3        2       1.0              1  7   \n",
       "123    871642       637            2        1       2.0              2  6   \n",
       "124    872180        76            2        1       2.0              1  7   \n",
       "125    883691       750            3        2       3.0              4  7   \n",
       "126    890189       290            2        1       1.0              7  6   \n",
       "127    905061       783            2        3       3.0              1  5   \n",
       "128    905745       761            2        1       3.0              2  6   \n",
       "129    914348       750            2        2       2.0              4  6   \n",
       "130    923841       450            3        2       1.0              2  6   \n",
       "131    924154       637            3        2       1.0              2  6   \n",
       "132    948936       512            2        1       1.0              1  5   \n",
       "133    950264       498            2        1       1.0              1  7   \n",
       "134    953842       831            2        1       1.0              3  7   \n",
       "135    961362       692            2        1       1.0              5  0   \n",
       "136    961962       750            3        2       3.0              4  5   \n",
       "137    963845       836            2        1       2.0              3  6   \n",
       "138    973106       537            2        1       1.0              5  0   \n",
       "139    978089        12            3        2       NaN              1  5   \n",
       "\n",
       "    gearbox_type  displacement if_charging     ...      engine_torque  \\\n",
       "0             AT           1.6           L     ...              150.7   \n",
       "1             AT           1.8           T     ...              230.0   \n",
       "2             AT           2.4           L     ...              225.0   \n",
       "3             AT           2.0           L     ...              190.0   \n",
       "4             MT           1.5           T     ...              215.0   \n",
       "5             MT           1.6           L     ...              155.0   \n",
       "6             MT           1.0           L     ...               85.0   \n",
       "7             AT           1.5           L     ...              146.0   \n",
       "8             AT           1.4           L     ...              132.4   \n",
       "9            DCT           1.6           T     ...              265.0   \n",
       "10            MT           1.5           L     ...              140.0   \n",
       "11            AT           1.5           L     ...              146.0   \n",
       "12            AT           2.0           T     ...              310.0   \n",
       "13            MT           1.5           T     ...              210.0   \n",
       "14           DCT           1.4           T     ...              250.0   \n",
       "15           DCT           1.4           T     ...              225.0   \n",
       "16            AT           1.4           L     ...              135.0   \n",
       "17           CVT           2.0           L     ...              200.0   \n",
       "18           DCT           1.5           T     ...              252.0   \n",
       "19            MT           1.5           L     ...              135.0   \n",
       "20            MT           1.5           L     ...              146.5   \n",
       "21           DCT           1.8           T     ...              250.0   \n",
       "22           DCT           1.4           T     ...              250.0   \n",
       "23            AT           1.5           L     ...              148.0   \n",
       "24           DCT           1.3           T     ...              185.0   \n",
       "25            AT           2.0           L     ...              190.0   \n",
       "26            AT           2.0           L     ...              190.0   \n",
       "27            MT           1.6           L     ...              160.0   \n",
       "28            MT           1.5           L     ...              143.0   \n",
       "29           CVT           1.6           L     ...              154.0   \n",
       "..           ...           ...         ...     ...                ...   \n",
       "110          DCT           1.6           L     ...              215.0   \n",
       "111           AT           1.5           T     ...              201.0   \n",
       "112          CVT           2.0           L     ...              155.5   \n",
       "113           AT           1.6           L     ...              140.0   \n",
       "114          CVT           1.5           L     ...              155.0   \n",
       "115           AT           1.6           L     ...              250.0   \n",
       "116          DCT           1.4           T     ...              199.0   \n",
       "117           AT           2.0           L     ...              245.0   \n",
       "118          DCT           1.8           T     ...              400.0   \n",
       "119           AT           2.0           T     ...              172.0   \n",
       "120           AT           1.8           L     ...              150.0   \n",
       "121           AT           1.5           L     ...              250.0   \n",
       "122          DCT           1.5           T     ...              240.0   \n",
       "123           AT           1.5           T     ...              360.0   \n",
       "124          DCT           2.0           T     ...              250.0   \n",
       "125          DCT           1.8           T     ...              146.5   \n",
       "126           MT           1.5           L     ...              160.0   \n",
       "127           MT           1.6           L     ...              200.0   \n",
       "128           AT           1.4           T     ...              155.0   \n",
       "129           AT           1.6           L     ...              190.0   \n",
       "130           AT           2.0           L     ...              142.0   \n",
       "131           AT           1.5           L     ...              150.0   \n",
       "132           MT           1.5           L     ...              250.0   \n",
       "133          DCT           1.5           T     ...              265.0   \n",
       "134          DCT           1.6           T     ...              198.0   \n",
       "135          CVT           2.0           L     ...              160.0   \n",
       "136           MT           1.6           L     ...              150.7   \n",
       "137           AT           1.6           L     ...              243.0   \n",
       "138          CVT           1.5           T     ...              140.0   \n",
       "139           MT           1.5           L     ...                NaN   \n",
       "\n",
       "     car_length  car_width  car_height  total_quality  equipment_quality  \\\n",
       "0          4270       1780        1630           1830               1325   \n",
       "1          4650       1850        1695           2075               1665   \n",
       "2          5213       1878        1772           2470               1840   \n",
       "3          4825       1825        1480           2000               1465   \n",
       "4          4715       1830        1780           2095               1570   \n",
       "5          4473       1706        1469           1600               1120   \n",
       "6          3730       1510        1860           1575                985   \n",
       "7          4370       1809        1461           1715               1280   \n",
       "8          4240       1750        1505           1570               1145   \n",
       "9          4475       1850        1655           2090               1541   \n",
       "10         4547       1734        1470           1620               1210   \n",
       "11         4718       1802        1466           1745               1295   \n",
       "12         5055       1860        1491           2250               1790   \n",
       "13         4335       1814        1695           1910               1495   \n",
       "14         4385       1831        1589           2020               1500   \n",
       "15         4348       1807        1574           1880               1425   \n",
       "16         4370       1700        1460           1500               1039   \n",
       "17         4672       1843        1678           2004               1557   \n",
       "18         4923       1854        1470           1865               1415   \n",
       "19         4360       1685        1820           1925               1325   \n",
       "20         4415       1685        1850           1825               1256   \n",
       "21         4870       1834        1472           2060               1520   \n",
       "22         4462       1796        1421           1795               1345   \n",
       "23         4582       1795        1458           1820               1286   \n",
       "24         4440       1833        1545           1773               1398   \n",
       "25         4550       1820        1685           2010               1625   \n",
       "26         4843       1856        1484           2020               1585   \n",
       "27         4160       1810        1635           1645               1270   \n",
       "28         4354       1840        1654           1670               1285   \n",
       "29         4630       1775        1480           1770               1305   \n",
       "..          ...        ...         ...            ...                ...   \n",
       "110        4534       1823        1483           1712               1337   \n",
       "111        4530       1900        1700           1920               1545   \n",
       "112        4705       1810        1680           1985               1440   \n",
       "113        4570       1775        1445           1642               1267   \n",
       "114        4440       1700        1490           1500               1090   \n",
       "115        4282       1706        1475           1635               1155   \n",
       "116        4415       1819        1625           1830               1455   \n",
       "117        4450       1855        1635           1980               1470   \n",
       "118        4748       1933        1697           2162               1787   \n",
       "119        4812       1903        1680           2275               1795   \n",
       "120        4650       1750        1505           1650               1275   \n",
       "121        4314       1809        1624           1690               1258   \n",
       "122        4671       1835        1464           1720               1270   \n",
       "123        4524       1838        1685           1967               1592   \n",
       "124        4765       1931        1655           2505               1960   \n",
       "125        4865       1820        1475           2000               1545   \n",
       "126        4220       1740        1625           1580               1206   \n",
       "127        4810       1795        1730           1950               1460   \n",
       "128        4278       1774        1646           1840               1430   \n",
       "129        3970       1682        1462           1600               1120   \n",
       "130        4869       1854        1472           1985               1565   \n",
       "131        4587       1825        1490           1675               1300   \n",
       "132        4520       1790        1750           1960               1435   \n",
       "133        4545       1855        1690           1876               1501   \n",
       "134        4480       1855        1645           2090               1576   \n",
       "135        4315       1783        1606           1930               1427   \n",
       "136        4487       1706        1470           1600               1120   \n",
       "137        4270       1780        1622           1752               1341   \n",
       "138        4816       1942        1669           2180               1708   \n",
       "139        4631       1789        1470           1625               1250   \n",
       "\n",
       "     rated_passenger  wheelbase  front_track  rear_track  \n",
       "0                  5       2590         1557        1570  \n",
       "1                  5       2700         1565        1565  \n",
       "2                  7       3088         1593        1601  \n",
       "3                  5       2775         1575        1560  \n",
       "4                  7       2760         1547        1550  \n",
       "5                  5       2603         1460        1500  \n",
       "6                  7       2500         1290        1290  \n",
       "7                  5       2662         1540        1562  \n",
       "8                  5       2600         1524        1529  \n",
       "9                  5       2670         1620        1631  \n",
       "10                 5       2600         1490        1470  \n",
       "11                 5       2700         1540        1558  \n",
       "12                 5       3108         1600        1627  \n",
       "13                 5       2560         1525        1520  \n",
       "14                 5       2603         1571        1575  \n",
       "15                 5       2680         1549        1521  \n",
       "16                 5       2570         1511        1515  \n",
       "17                 5       2705         1597        1589  \n",
       "18                 5       2829         1606        1609  \n",
       "19               7-8       2750         1425        1435  \n",
       "20                 5       2720         1420        1440  \n",
       "21                 5       2803         1577        1550  \n",
       "22                 5       2629         1552        1520  \n",
       "23                 5       2700         1555        1560  \n",
       "24                 5       2700         1556        1562  \n",
       "25                 5       2620         1565        1565  \n",
       "26                 5       2737         1585        1588  \n",
       "27                 5       2560         1560        1560  \n",
       "28                 5       2610         1585        1586  \n",
       "29                 5       2700         1535        1535  \n",
       "..               ...        ...          ...         ...  \n",
       "110                5       2648         1553        1544  \n",
       "111                5       2700         1601        1602  \n",
       "112                5       2670         1540        1540  \n",
       "113                5       2700         1549        1562  \n",
       "114                5       2550         1460        1460  \n",
       "115                5       2603         1460        1500  \n",
       "116                5       2636         1544        1544  \n",
       "117                5       2640         1614        1615  \n",
       "118                5       2850         1641        1642  \n",
       "119                5       2857         1645        1645  \n",
       "120                5       2650         1500        1485  \n",
       "121                5       2585         1526        1536  \n",
       "122                5       2715         1562        1571  \n",
       "123                5       2690         1563        1565  \n",
       "124                5       2950         1655        1606  \n",
       "125                5       2812         1552        1551  \n",
       "126                5       2550         1490        1496  \n",
       "127                7       2760         1535        1530  \n",
       "128                5       2555         1540        1540  \n",
       "129                5       2470         1463        1456  \n",
       "130                5       2737         1585        1587  \n",
       "131                5       2687         1562        1548  \n",
       "132              6-7       2700         1450        1480  \n",
       "133                5       2700         1574        1593  \n",
       "134                5       2670         1625        1636  \n",
       "135                5       2630         1540        1545  \n",
       "136                5       2603         1460        1500  \n",
       "137                5       2590         1557        1570  \n",
       "138                5       2820         1652        1671  \n",
       "139                5       2650         1502        1492  \n",
       "\n",
       "[140 rows x 30 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "\n",
    "for col_name in df.drop(['class_id','sale_date','sale_quantity','brand_id'], axis=1).columns.values:\n",
    "    gd = df.groupby(['class_id',col_name]).sum().sort_values(ascending=False, by=['sale_quantity']).reset_index()\n",
    "    modes[col_name] = gd.groupby('class_id').first().reset_index()[col_name]\n",
    "\n",
    "modes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "class_id                 140\n",
       "brand_id                 140\n",
       "compartment              140\n",
       "type_id                  140\n",
       "level_id                 139\n",
       "department_id            140\n",
       "TR                       140\n",
       "gearbox_type             140\n",
       "displacement             140\n",
       "if_charging              140\n",
       "price_level              140\n",
       "price                    130\n",
       "driven_type_id           140\n",
       "fuel_type_id             140\n",
       "newenergy_type_id        140\n",
       "emission_standards_id    140\n",
       "if_MPV_id                140\n",
       "if_luxurious_id          140\n",
       "power                    140\n",
       "cylinder_number          140\n",
       "engine_torque            139\n",
       "car_length               140\n",
       "car_width                140\n",
       "car_height               140\n",
       "total_quality            140\n",
       "equipment_quality        140\n",
       "rated_passenger          140\n",
       "wheelbase                140\n",
       "front_track              140\n",
       "rear_track               140\n",
       "dtype: int64"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "modes.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
